|
500
|
How can I filter items for dates before a specified date
extree1.BeginUpdate();
exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("Dates") as exontrol.EXTREELib.Column);
var_Column.SortType = exontrol.EXTREELib.SortTypeEnum.SortDate;
var_Column.DisplayFilterButton = true;
var_Column.DisplayFilterPattern = true;
var_Column.DisplayFilterDate = true;
var_Column.FilterList = exontrol.EXTREELib.FilterListEnum.exShowFocusItem | exontrol.EXTREELib.FilterListEnum.exNoItems;
var_Column.Filter = "to 12/27/2010";
var_Column.FilterType = exontrol.EXTREELib.FilterTypeEnum.exDate;
exontrol.EXTREELib.Items var_Items = extree1.Items;
var_Items.AddItem(Convert.ToDateTime("12/27/2010",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("12/28/2010",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("12/29/2010",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("12/30/2010",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("12/31/2010",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
extree1.ApplyFilter();
extree1.EndUpdate();
|
|
499
|
Is it possible to filter dates
extree1.BeginUpdate();
exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("Dates") as exontrol.EXTREELib.Column);
var_Column.SortType = exontrol.EXTREELib.SortTypeEnum.SortDate;
var_Column.DisplayFilterButton = true;
var_Column.DisplayFilterPattern = true;
var_Column.DisplayFilterDate = true;
var_Column.FilterList = exontrol.EXTREELib.FilterListEnum.exShowFocusItem | exontrol.EXTREELib.FilterListEnum.exNoItems;
exontrol.EXTREELib.Items var_Items = extree1.Items;
var_Items.AddItem(Convert.ToDateTime("12/27/2010",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("12/28/2010",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("12/29/2010",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("12/30/2010",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("12/31/2010",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
extree1.EndUpdate();
|
|
498
|
Is it possible to change the Exclude field name to something different, in the drop down filter window
extree1.BeginUpdate();
extree1.LinesAtRoot = exontrol.EXTREELib.LinesAtRootEnum.exLinesAtRoot;
extree1.set_Description(exontrol.EXTREELib.DescriptionTypeEnum.exFilterBarExclude,"Leaving out");
exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("Items") as exontrol.EXTREELib.Column);
var_Column.DisplayFilterButton = true;
var_Column.DisplayFilterPattern = false;
var_Column.FilterList = exontrol.EXTREELib.FilterListEnum.exShowExclude | exontrol.EXTREELib.FilterListEnum.exShowFocusItem | exontrol.EXTREELib.FilterListEnum.exShowCheckBox;
exontrol.EXTREELib.Items var_Items = extree1.Items;
int h = var_Items.AddItem("Root 1");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(h,null,"Child 2");
var_Items.set_ExpandItem(h,true);
h = var_Items.AddItem("Root 2");
var_Items.InsertItem(h,null,"Child 1");
extree1.EndUpdate();
|
|
497
|
How can I display the Exclude field in the drop down filter window
extree1.BeginUpdate();
extree1.LinesAtRoot = exontrol.EXTREELib.LinesAtRootEnum.exLinesAtRoot;
exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("Items") as exontrol.EXTREELib.Column);
var_Column.DisplayFilterButton = true;
var_Column.DisplayFilterPattern = false;
var_Column.FilterList = exontrol.EXTREELib.FilterListEnum.exShowExclude | exontrol.EXTREELib.FilterListEnum.exShowFocusItem | exontrol.EXTREELib.FilterListEnum.exShowCheckBox;
exontrol.EXTREELib.Items var_Items = extree1.Items;
int h = var_Items.AddItem("Root 1");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(h,null,"Child 2");
var_Items.set_ExpandItem(h,true);
h = var_Items.AddItem("Root 2");
var_Items.InsertItem(h,null,"Child 1");
extree1.EndUpdate();
|
|
496
|
Is it possible to show and ensure the focused item from the control, in the drop down filter window
extree1.BeginUpdate();
extree1.LinesAtRoot = exontrol.EXTREELib.LinesAtRootEnum.exLinesAtRoot;
exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("Items") as exontrol.EXTREELib.Column);
var_Column.DisplayFilterButton = true;
var_Column.DisplayFilterPattern = false;
var_Column.FilterList = exontrol.EXTREELib.FilterListEnum.exShowFocusItem | exontrol.EXTREELib.FilterListEnum.exShowCheckBox;
exontrol.EXTREELib.Items var_Items = extree1.Items;
int h = var_Items.AddItem("Root 1");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(h,null,"Child 2");
var_Items.set_ExpandItem(h,true);
h = var_Items.AddItem("Root 2");
var_Items.InsertItem(h,null,"Child 1");
var_Items.set_SelectItem(var_Items.InsertItem(h,null,"Child 2"),true);
var_Items.set_ExpandItem(h,true);
extree1.EndUpdate();
|
|
495
|
Is it possible to show only blanks items with no listed items from the control
extree1.BeginUpdate();
extree1.LinesAtRoot = exontrol.EXTREELib.LinesAtRootEnum.exLinesAtRoot;
exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("Items") as exontrol.EXTREELib.Column);
var_Column.DisplayFilterButton = true;
var_Column.DisplayFilterPattern = false;
var_Column.FilterList = exontrol.EXTREELib.FilterListEnum.exShowBlanks | exontrol.EXTREELib.FilterListEnum.exNoItems;
exontrol.EXTREELib.Items var_Items = extree1.Items;
int h = var_Items.AddItem("Root 1");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(h,null,"Child 2");
var_Items.set_ExpandItem(h,true);
h = var_Items.AddItem("Root 2");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(h,null,"Child 2");
extree1.EndUpdate();
|
|
494
|
How can I include the blanks items in the drop down filter window
extree1.BeginUpdate();
extree1.LinesAtRoot = exontrol.EXTREELib.LinesAtRootEnum.exLinesAtRoot;
exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("Items") as exontrol.EXTREELib.Column);
var_Column.DisplayFilterButton = true;
var_Column.DisplayFilterPattern = false;
var_Column.FilterList = exontrol.EXTREELib.FilterListEnum.exShowBlanks | exontrol.EXTREELib.FilterListEnum.exShowCheckBox;
exontrol.EXTREELib.Items var_Items = extree1.Items;
int h = var_Items.AddItem("Root 1");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(h,null,"Child 2");
var_Items.set_ExpandItem(h,true);
h = var_Items.AddItem("Root 2");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(h,null,"Child 2");
extree1.EndUpdate();
|
|
493
|
How can I select multiple items in the drop down filter window, using check-boxes
extree1.BeginUpdate();
extree1.LinesAtRoot = exontrol.EXTREELib.LinesAtRootEnum.exLinesAtRoot;
exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("Items") as exontrol.EXTREELib.Column);
var_Column.DisplayFilterButton = true;
var_Column.DisplayFilterPattern = false;
var_Column.FilterList = exontrol.EXTREELib.FilterListEnum.exShowCheckBox;
exontrol.EXTREELib.Items var_Items = extree1.Items;
int h = var_Items.AddItem("Root 1");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(h,null,"Child 2");
var_Items.set_ExpandItem(h,true);
h = var_Items.AddItem("Root 2");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(h,null,"Child 2");
extree1.EndUpdate();
|
|
492
|
Is it possible to allow a single item being selected in the drop down filter window
extree1.BeginUpdate();
extree1.LinesAtRoot = exontrol.EXTREELib.LinesAtRootEnum.exLinesAtRoot;
exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("Items") as exontrol.EXTREELib.Column);
var_Column.DisplayFilterButton = true;
var_Column.DisplayFilterPattern = false;
var_Column.FilterList = exontrol.EXTREELib.FilterListEnum.exSingleSel;
exontrol.EXTREELib.Items var_Items = extree1.Items;
int h = var_Items.AddItem("Root 1");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(h,null,"Child 2");
var_Items.set_ExpandItem(h,true);
h = var_Items.AddItem("Root 2");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(h,null,"Child 2");
extree1.EndUpdate();
|
|
491
|
How can I display no (All) item in the drop down filter window
extree1.BeginUpdate();
extree1.LinesAtRoot = exontrol.EXTREELib.LinesAtRootEnum.exLinesAtRoot;
extree1.set_Description(exontrol.EXTREELib.DescriptionTypeEnum.exFilterBarAll,"");
exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("Items") as exontrol.EXTREELib.Column);
var_Column.DisplayFilterButton = true;
var_Column.DisplayFilterPattern = true;
var_Column.FilterList = exontrol.EXTREELib.FilterListEnum.exNoItems;
exontrol.EXTREELib.Items var_Items = extree1.Items;
int h = var_Items.AddItem("Root 1");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(h,null,"Child 2");
var_Items.set_ExpandItem(h,true);
h = var_Items.AddItem("Root 2");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(h,null,"Child 2");
extree1.EndUpdate();
|
|
490
|
Is it possible to display no items in the drop down filter window, so only the pattern is visible
extree1.BeginUpdate();
extree1.LinesAtRoot = exontrol.EXTREELib.LinesAtRootEnum.exLinesAtRoot;
exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("Items") as exontrol.EXTREELib.Column);
var_Column.DisplayFilterButton = true;
var_Column.DisplayFilterPattern = true;
var_Column.FilterList = exontrol.EXTREELib.FilterListEnum.exNoItems;
exontrol.EXTREELib.Items var_Items = extree1.Items;
int h = var_Items.AddItem("Root 1");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(h,null,"Child 2");
var_Items.set_ExpandItem(h,true);
h = var_Items.AddItem("Root 2");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(h,null,"Child 2");
extree1.EndUpdate();
|
|
489
|
How do I hide the selection
extree1.BeginUpdate();
extree1.MarkSearchColumn = false;
extree1.SelForeColor = extree1.ForeColor;
extree1.SelBackColor = extree1.BackColor;
extree1.ShowFocusRect = false;
exontrol.EXTREELib.Columns var_Columns = extree1.Columns;
exontrol.EXTREELib.Column var_Column = (var_Columns.Add("Format") as exontrol.EXTREELib.Column);
var_Column.FormatColumn = "type(value) in (0,1) ? 'null' : ( dbl(value)<0 ? '<fgcolor=FF0000>'+ (value format '2|.|3|,|1' ) : (dbl(value)>0 ? '<fgcolor=00" +
"00FF>+'+(value format '2|.|3|,' ): '0.00') )";
var_Column.set_Def(exontrol.EXTREELib.DefColumnEnum.exCellCaptionFormat,1);
exontrol.EXTREELib.Items var_Items = extree1.Items;
var_Items.AddItem(10);
var_Items.AddItem(-8);
extree1.EndUpdate();
|
|
488
|
How do I access the cells, or how do I get the values in the columns
exontrol.EXTREELib.Columns var_Columns = extree1.Columns;
var_Columns.Add("C1");
var_Columns.Add("C2");
var_Columns.Add("C3");
exontrol.EXTREELib.Items var_Items = extree1.Items;
int h = var_Items.AddItem("Item 1");
var_Items.set_CellCaption(h,1,"SubItem 1.1");
var_Items.set_CellCaption(h,2,"SubItem 1.2");
System.Diagnostics.Debug.Print( var_Items.get_CellCaption(h,0).ToString() );
|
|
487
|
Is it possible to load child items when clicking the +/- button
// BeforeExpandItem event - Fired before an item is about to be expanded (collapsed).
private void extree1_BeforeExpandItem(object sender,int Item,ref object Cancel)
{
exontrol.EXTREELib.Items var_Items = extree1.Items;
var_Items.InsertItem(Item,null,"new");
var_Items.set_ItemHasChildren(var_Items.InsertItem(Item,null,"new"),true);
var_Items.InsertItem(Item,null,"new");
}
//this.extree1.BeforeExpandItem += new exontrol.EXTREELib.exg2antt.BeforeExpandItemEventHandler(this.extree1_BeforeExpandItem);
extree1.LinesAtRoot = exontrol.EXTREELib.LinesAtRootEnum.exLinesAtRoot;
extree1.Columns.Add("Default");
exontrol.EXTREELib.Items var_Items = extree1.Items;
var_Items.set_ItemHasChildren(var_Items.AddItem("aka"),true);
var_Items.AddItem("next item");
|
|
486
|
How can I change the check-boxes appearance
extree1.LinesAtRoot = exontrol.EXTREELib.LinesAtRootEnum.exLinesAtRoot;
exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("Default") as exontrol.EXTREELib.Column);
var_Column.set_Def(exontrol.EXTREELib.DefColumnEnum.exCellHasCheckBox,true);
var_Column.PartialCheck = true;
exontrol.EXTREELib.Items var_Items = extree1.Items;
int h = var_Items.AddItem("Root");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(h,null,"Child 2");
var_Items.set_ExpandItem(h,true);
exontrol.EXTREELib.Appearance var_Appearance = extree1.VisualAppearance;
var_Appearance.Add(1,"XP:Button 3 12");
var_Appearance.Add(2,"XP:Button 3 11");
var_Appearance.Add(3,"XP:Button 3 10");
extree1.set_CheckImage(exontrol.EXTREELib.CheckStateEnum.Unchecked,16777216);
extree1.set_CheckImage(exontrol.EXTREELib.CheckStateEnum.Checked,33554432);
extree1.set_CheckImage(exontrol.EXTREELib.CheckStateEnum.PartialChecked,50331648);
|
|
485
|
How can I initiate the OLE Drag and Drop support
// OLEStartDrag event is not supported. Use the DragEnter,DragLeave,DragOver, DragDrop ... events.
extree1.OLEDropMode = exontrol.EXTREELib.exOLEDropModeEnum.exOLEDropManual;
extree1.LinesAtRoot = exontrol.EXTREELib.LinesAtRootEnum.exLinesAtRoot;
extree1.Columns.Add("Default");
exontrol.EXTREELib.Items var_Items = extree1.Items;
int h = var_Items.AddItem("Root");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(h,null,"Child 2");
var_Items.set_ExpandItem(h,true);
|
|
484
|
How can I apply the same ConditionalFormat on more than 1(one) column (multiple columns and not on item)
extree1.BeginUpdate();
exontrol.EXTREELib.ConditionalFormat var_ConditionalFormat = extree1.ConditionalFormats.Add("1","K1");
var_ConditionalFormat.BackColor = Color.FromArgb(255,0,0);
var_ConditionalFormat.ApplyTo = (exontrol.EXTREELib.FormatApplyToEnum)0x1;
exontrol.EXTREELib.ConditionalFormat var_ConditionalFormat1 = extree1.ConditionalFormats.Add("1","K2");
var_ConditionalFormat1.BackColor = Color.FromArgb(255,0,0);
var_ConditionalFormat1.ApplyTo = (exontrol.EXTREELib.FormatApplyToEnum)0x2;
extree1.MarkSearchColumn = false;
extree1.DrawGridLines = exontrol.EXTREELib.GridLinesEnum.exRowLines;
exontrol.EXTREELib.Columns var_Columns = extree1.Columns;
var_Columns.Add("Column 1");
var_Columns.Add("Column 2");
var_Columns.Add("Column 3");
exontrol.EXTREELib.Items var_Items = extree1.Items;
var_Items.AddItem(null);
var_Items.AddItem(null);
var_Items.AddItem(null);
extree1.EndUpdate();
|
|
483
|
Is it possible to display empty strings for 0 values
(extree1.Columns.Add("Currency") as exontrol.EXTREELib.Column).FormatColumn = "dbl(value) ? currency(dbl(value)) : ``";
exontrol.EXTREELib.Items var_Items = extree1.Items;
var_Items.AddItem(1.23);
var_Items.AddItem(2.34);
var_Items.AddItem(0);
var_Items.AddItem(10000.99);
|
|
482
|
Is it possible to display empty strings for 0 values
extree1.Columns.Add("Number");
(extree1.Columns.Add("Currency") as exontrol.EXTREELib.Column).ComputedField = "%0 ? currency(%0) : ``";
exontrol.EXTREELib.Items var_Items = extree1.Items;
var_Items.AddItem(1.23);
var_Items.AddItem(2.34);
var_Items.AddItem(0);
var_Items.AddItem(10000.99);
|
|
481
|
How can I get the list of items as they are displayed
extree1.BeginUpdate();
extree1.BackColorAlternate = Color.FromArgb(240,240,240);
extree1.Columns.Add("Names");
exontrol.EXTREELib.Items var_Items = extree1.Items;
var_Items.AddItem("Mantel");
var_Items.AddItem("Mechanik");
var_Items.AddItem("Motor");
var_Items.AddItem("Murks");
var_Items.AddItem("Märchen");
var_Items.AddItem("Möhren");
var_Items.AddItem("Mühle");
extree1.Columns[0].SortOrder = exontrol.EXTREELib.SortOrderEnum.SortAscending;
extree1.EndUpdate();
System.Diagnostics.Debug.Print( extree1.GetItems(1).ToString() );
|
|
480
|
Is posible to reduce the size of the picture to be shown in the column's caption
extree1.BeginUpdate();
extree1.set_HTMLPicture("pic1","c:\\exontrol\\images\\zipdisk.gif");
extree1.HeaderHeight = 48;
(extree1.Columns.Add("DefaultSize") as exontrol.EXTREELib.Column).HTMLCaption = "Default-Size <img>pic1</img> Picture";
(extree1.Columns.Add("CustomSize") as exontrol.EXTREELib.Column).HTMLCaption = "Custom-Size <img>pic1:16</img> Picture";
extree1.EndUpdate();
|
|
479
|
How can I change the color, font, bold etc for the items/cells in the same column or for the entire column
extree1.BeginUpdate();
extree1.MarkSearchColumn = false;
exontrol.EXTREELib.ConditionalFormat var_ConditionalFormat = extree1.ConditionalFormats.Add("1",null);
var_ConditionalFormat.Bold = true;
var_ConditionalFormat.ForeColor = Color.FromArgb(255,0,0);
var_ConditionalFormat.ApplyTo = (exontrol.EXTREELib.FormatApplyToEnum)0x1;
extree1.Columns.Add("C1");
exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("C2") as exontrol.EXTREELib.Column);
var_Column.HeaderBold = true;
var_Column.HTMLCaption = "<fgcolor=FF0000>C2";
exontrol.EXTREELib.Items var_Items = extree1.Items;
var_Items.set_CellCaption(var_Items.AddItem(10),1,11);
var_Items.set_CellCaption(var_Items.AddItem(12),1,13);
extree1.EndUpdate();
|
|
478
|
The item is not getting selected when clicking the cell's checkbox. What should I do
// CellStateChanged event - Fired after cell's state has been changed.
private void extree1_CellStateChanged(object sender,int Item,int ColIndex)
{
extree1.Items.set_SelectItem(Item,true);
}
//this.extree1.CellStateChanged += new exontrol.EXTREELib.exg2antt.CellStateChangedEventHandler(this.extree1_CellStateChanged);
(extree1.Columns.Add("Check") as exontrol.EXTREELib.Column).set_Def(exontrol.EXTREELib.DefColumnEnum.exCellHasCheckBox,true);
exontrol.EXTREELib.Items var_Items = extree1.Items;
var_Items.AddItem(0);
var_Items.AddItem(1);
var_Items.AddItem(2);
var_Items.AddItem(3);
|
|
477
|
Is it possible to limit the height of the item while resizing
// AddItem event - Occurs after a new Item has been inserted to Items collection.
private void extree1_AddItem(object sender,int Item)
{
extree1.Items.set_ItemMinHeight(Item,18);
extree1.Items.set_ItemMaxHeight(Item,72);
}
//this.extree1.AddItem += new exontrol.EXTREELib.exg2antt.AddItemEventHandler(this.extree1_AddItem);
extree1.BeginUpdate();
extree1.ItemsAllowSizing = exontrol.EXTREELib.ItemsAllowSizingEnum.exResizeItem;
extree1.ScrollBySingleLine = false;
extree1.BackColorAlternate = Color.FromArgb(240,240,240);
extree1.Columns.Add("Names");
exontrol.EXTREELib.Items var_Items = extree1.Items;
var_Items.AddItem("Mantel");
var_Items.AddItem("Mechanik");
var_Items.AddItem("Motor");
var_Items.AddItem("Murks");
var_Items.AddItem("Märchen");
var_Items.AddItem("Möhren");
var_Items.AddItem("Mühle");
extree1.Columns[0].SortOrder = exontrol.EXTREELib.SortOrderEnum.SortAscending;
extree1.EndUpdate();
|
|
476
|
Is it possible to copy the hierarchy of the control using the GetItems method
extree1.LinesAtRoot = exontrol.EXTREELib.LinesAtRootEnum.exLinesAtRoot;
extree1.Columns.Add("Def");
exontrol.EXTREELib.Items var_Items = extree1.Items;
int h = var_Items.AddItem("Root");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(h,null,"Child 2");
extree1.PutItems(extree1.GetItems(-1),null);
|
|
475
|
How can I show the child items with no identation
extree1.LinesAtRoot = exontrol.EXTREELib.LinesAtRootEnum.exGroupLinesOutside;
extree1.Indent = 12;
extree1.HasLines = exontrol.EXTREELib.HierarchyLineEnum.exThinLine;
extree1.Columns.Add("Default");
exontrol.EXTREELib.Items var_Items = extree1.Items;
int h = var_Items.AddItem("Root 1");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(h,null,"Child 2");
var_Items.InsertItem(h,null,"Child 3");
var_Items.set_ExpandItem(h,true);
h = var_Items.AddItem("Root 2");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(h,null,"Child 2");
var_Items.InsertItem(h,null,"Child 3");
|
|
474
|
Is there other ways of showing the hierarchy lines (exGroupLinesAtRoot)
extree1.LinesAtRoot = exontrol.EXTREELib.LinesAtRootEnum.exGroupLinesAtRoot;
extree1.Indent = 12;
extree1.Columns.Add("Default");
exontrol.EXTREELib.Items var_Items = extree1.Items;
int h = var_Items.AddItem("Root");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(h,null,"Child 2");
var_Items.InsertItem(h,null,"Child 3");
var_Items.set_ExpandItem(h,true);
|
|
473
|
Is there other ways of showing the hierarchy lines (exGroupLinesOutside)
extree1.LinesAtRoot = exontrol.EXTREELib.LinesAtRootEnum.exGroupLinesOutside;
extree1.Indent = 12;
extree1.Columns.Add("Default");
exontrol.EXTREELib.Items var_Items = extree1.Items;
int h = var_Items.AddItem("Root 1");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(h,null,"Child 2");
var_Items.InsertItem(h,null,"Child 3");
var_Items.set_ExpandItem(h,true);
h = var_Items.AddItem("Root 2");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(h,null,"Child 2");
var_Items.InsertItem(h,null,"Child 3");
|
|
472
|
Is there other ways of showing the hierarchy lines (exGroupLinesInsideLeaf)
extree1.LinesAtRoot = exontrol.EXTREELib.LinesAtRootEnum.exGroupLinesInsideLeaf;
extree1.Indent = 12;
extree1.Columns.Add("Default");
exontrol.EXTREELib.Items var_Items = extree1.Items;
int h = var_Items.AddItem("Root");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(h,null,"Child 2");
var_Items.InsertItem(h,null,"Child 3");
var_Items.set_ExpandItem(h,true);
|
|
471
|
Is there other ways of showing the hierarchy lines (exGroupLinesInside)
extree1.LinesAtRoot = exontrol.EXTREELib.LinesAtRootEnum.exGroupLinesInside;
extree1.Indent = 12;
extree1.Columns.Add("Default");
exontrol.EXTREELib.Items var_Items = extree1.Items;
int h = var_Items.AddItem("Root");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(h,null,"Child 2");
var_Items.InsertItem(h,null,"Child 3");
var_Items.set_ExpandItem(h,true);
|
|
470
|
Is there other ways of showing the hierarchy lines (exGroupLines)
extree1.LinesAtRoot = exontrol.EXTREELib.LinesAtRootEnum.exGroupLines;
extree1.Indent = 12;
extree1.Columns.Add("Default");
exontrol.EXTREELib.Items var_Items = extree1.Items;
int h = var_Items.AddItem("Root");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(var_Items.InsertItem(h,null,"Child 2"),null,"SubChild 2");
var_Items.InsertItem(h,null,"Child 3");
var_Items.set_ExpandItem(h,true);
|
|
469
|
Does your control supports multiple lines tooltip
extree1.set_HTMLPicture("pic1","c:\\exontrol\\images\\zipdisk.gif");
extree1.ToolTipDelay = 1;
(extree1.Columns.Add("tootip") as exontrol.EXTREELib.Column).ToolTip = "<br><font Tahoma;10>This</font> is a <b>multi-lines</b> tooltip assigned to a column. The tooltip supports built-in HTML tags, " +
"icons and pictures.<br><br><br><img>pic1</img> picture ... <br><br>";
|
|
468
|
How can I prevent highlighting the column from the cursor - point
extree1.VisualAppearance.Add(1,"gBFLBCJwBAEHhEJAEGg4BI0IQAAYAQGKIYBkAKBQAGaAoDDUOQzQwAAxDKKUEwsACEIrjKCYVgOHYYRrIMYgBCMJhLEoaZLhEZRQiqDYtRDFQBSDDcPw/EaRZohGaYJ" +
"gEgI=");
extree1.set_Background32(exontrol.EXTREELib.BackgroundPartEnum.exCursorHoverColumn,0x1000000);
(extree1.Columns.Add("S") as exontrol.EXTREELib.Column).Width = 32;
(extree1.Columns.Add("Level 1") as exontrol.EXTREELib.Column).LevelKey = 1;
(extree1.Columns.Add("Level 2") as exontrol.EXTREELib.Column).LevelKey = 1;
(extree1.Columns.Add("Level 3") as exontrol.EXTREELib.Column).LevelKey = 1;
(extree1.Columns.Add("E1") as exontrol.EXTREELib.Column).Width = 32;
(extree1.Columns.Add("E2") as exontrol.EXTREELib.Column).Width = 32;
(extree1.Columns.Add("E3") as exontrol.EXTREELib.Column).Width = 32;
(extree1.Columns.Add("E4") as exontrol.EXTREELib.Column).Width = 32;
|
|
467
|
Is there any option to show the tooltip programmatically
// MouseMove event - Occurs when the user moves the mouse.
private void extree1_MouseMoveEvent(object sender,short Button,short Shift,int X,int Y)
{
extree1.ShowToolTip(extree1.get_ItemFromPoint(-1,-1,c,hit).ToString(),"","8","8",null);
}
//this.extree1.MouseMoveEvent += new exontrol.EXTREELib.exg2antt.MouseMoveEventHandler(this.extree1_MouseMoveEvent);
extree1.BeginUpdate();
extree1.Columns.Add("Def");
exontrol.EXTREELib.Items var_Items = extree1.Items;
var_Items.AddItem("Item 1");
var_Items.AddItem("Item 2");
var_Items.AddItem("Item 3");
extree1.EndUpdate();
|
|
466
|
Is it possible to prevent changing the rows/items colors by selection
extree1.SelBackMode = exontrol.EXTREELib.BackModeEnum.exTransparent;
(extree1.Columns.Add("HTML") as exontrol.EXTREELib.Column).set_Def(exontrol.EXTREELib.DefColumnEnum.exCellCaptionFormat,1);
exontrol.EXTREELib.Items var_Items = extree1.Items;
var_Items.AddItem("<font ;12>T</font>his <b>is</b> an <a>html</a> <font Tahoma><fgcolor=FF0000>text</fgcolor></font>.");
var_Items.set_SelectItem(var_Items.AddItem("<font ;6>This</font> <b>is</b> another <a>html</a> <font Tahoma><fgcolor=FF0000>text</fgcolor></font>."),true);
|
|
465
|
Is it possible to specify the cell's value but still want to display some formatted text instead the value
extree1.BeginUpdate();
extree1.MarkSearchColumn = false;
extree1.Columns.Add("Value");
extree1.Columns.Add("FormatCell");
exontrol.EXTREELib.Items var_Items = extree1.Items;
int h = var_Items.AddItem(1);
var_Items.set_CellCaption(h,1,12);
var_Items.set_FormatCell(h,1,"currency(value)");
h = var_Items.AddItem(Convert.ToDateTime("1/1/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.set_CellCaption(h,1,Convert.ToDateTime("1/1/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.set_CellCaptionFormat(h,1,exontrol.EXTREELib.CaptionFormatEnum.exHTML);
var_Items.set_FormatCell(h,1,"longdate(value) replace '2001' with '<b>2001</b>'");
extree1.EndUpdate();
|
|
464
|
How can I simulate displaying groups
extree1.BeginUpdate();
extree1.HasLines = exontrol.EXTREELib.HierarchyLineEnum.exNoLine;
extree1.ScrollBySingleLine = true;
extree1.MarkSearchColumn = false;
exontrol.EXTREELib.Columns var_Columns = extree1.Columns;
var_Columns.Add("Name");
var_Columns.Add("A");
var_Columns.Add("B");
var_Columns.Add("C");
exontrol.EXTREELib.Items var_Items = extree1.Items;
int h = var_Items.AddItem("Group 1");
var_Items.set_CellHAlignment(h,0,exontrol.EXTREELib.AlignmentEnum.CenterAlignment);
var_Items.set_ItemDivider(h,0);
var_Items.set_ItemDividerLineAlignment(h,exontrol.EXTREELib.DividerAlignmentEnum.DividerBoth);
var_Items.set_ItemHeight(h,24);
var_Items.set_SortableItem(h,false);
int h1 = var_Items.InsertItem(h,null,"Child 1");
var_Items.set_CellCaption(h1,1,1);
var_Items.set_CellCaption(h1,2,2);
var_Items.set_CellCaption(h1,3,3);
h1 = var_Items.InsertItem(h,null,"Child 2");
var_Items.set_CellCaption(h1,1,4);
var_Items.set_CellCaption(h1,2,5);
var_Items.set_CellCaption(h1,3,6);
var_Items.set_ExpandItem(h,true);
h = var_Items.AddItem("Group 2");
var_Items.set_CellHAlignment(h,0,exontrol.EXTREELib.AlignmentEnum.CenterAlignment);
var_Items.set_ItemDivider(h,0);
var_Items.set_ItemDividerLineAlignment(h,exontrol.EXTREELib.DividerAlignmentEnum.DividerBoth);
var_Items.set_ItemHeight(h,24);
var_Items.set_SortableItem(h,false);
h1 = var_Items.InsertItem(h,null,"Child 1");
var_Items.set_CellCaption(h1,1,1);
var_Items.set_CellCaption(h1,2,2);
var_Items.set_CellCaption(h1,3,3);
h1 = var_Items.InsertItem(h,null,"Child 2");
var_Items.set_CellCaption(h1,1,4);
var_Items.set_CellCaption(h1,2,5);
var_Items.set_CellCaption(h1,3,6);
var_Items.set_ExpandItem(h,true);
extree1.EndUpdate();
|
|
463
|
How can I collapse all items
extree1.BeginUpdate();
extree1.LinesAtRoot = exontrol.EXTREELib.LinesAtRootEnum.exLinesAtRoot;
extree1.Columns.Add("Items");
exontrol.EXTREELib.Items var_Items = extree1.Items;
int h = var_Items.AddItem("Root 1");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(h,null,"Child 2");
h = var_Items.AddItem("Root 2");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(h,null,"Child 2");
var_Items.set_ExpandItem(0,false);
extree1.EndUpdate();
|
|
462
|
How can I expand all items
extree1.BeginUpdate();
extree1.LinesAtRoot = exontrol.EXTREELib.LinesAtRootEnum.exLinesAtRoot;
extree1.Columns.Add("Items");
exontrol.EXTREELib.Items var_Items = extree1.Items;
int h = var_Items.AddItem("Root 1");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(h,null,"Child 2");
h = var_Items.AddItem("Root 2");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(h,null,"Child 2");
var_Items.set_ExpandItem(0,true);
extree1.EndUpdate();
|
|
461
|
Can I use PNG images to display pictures in the control
extree1.set_HTMLPicture("pic1","c:\\exontrol\\images\\card.png");
extree1.HeaderHeight = 48;
(extree1.Columns.Add("ColumnName") as exontrol.EXTREELib.Column).HTMLCaption = "<b>HTML</b> Column <img>pic1</img> Picture";
|
|
460
|
Is it possible to move an item from a parent to another
extree1.BeginUpdate();
extree1.LinesAtRoot = exontrol.EXTREELib.LinesAtRootEnum.exLinesAtRoot;
extree1.Columns.Add("Items");
exontrol.EXTREELib.Items var_Items = extree1.Items;
var_Items.AddItem("A");
var_Items.AddItem("B");
var_Items.InsertItem(var_Items.AddItem("C"),"","D");
var_Items.SetParent(var_Items.get_FindItem("D",0,null),var_Items.get_FindItem("A",0,null));
extree1.EndUpdate();
|
|
459
|
How can I change the identation for an item
extree1.BeginUpdate();
extree1.LinesAtRoot = exontrol.EXTREELib.LinesAtRootEnum.exLinesAtRoot;
extree1.Columns.Add("Items");
exontrol.EXTREELib.Items var_Items = extree1.Items;
var_Items.AddItem("A");
var_Items.AddItem("B");
var_Items.InsertItem(var_Items.AddItem("C"),"","D");
var_Items.SetParent(var_Items.get_FindItem("D",0,null),0);
extree1.EndUpdate();
|
|
458
|
How can I filter programatically using more columns
extree1.BeginUpdate();
extree1.MarkSearchColumn = false;
exontrol.EXTREELib.Columns var_Columns = extree1.Columns;
var_Columns.Add("Car");
var_Columns.Add("Equipment");
exontrol.EXTREELib.Items var_Items = extree1.Items;
var_Items.set_CellCaption(var_Items.AddItem("Mazda"),1,"Air Bag");
var_Items.set_CellCaption(var_Items.AddItem("Toyota"),1,"Air Bag,Air condition");
var_Items.set_CellCaption(var_Items.AddItem("Ford"),1,"Air condition");
var_Items.set_CellCaption(var_Items.AddItem("Nissan"),1,"Air Bag,ABS,ESP");
var_Items.set_CellCaption(var_Items.AddItem("Mazda"),1,"Air Bag, ABS,ESP");
var_Items.set_CellCaption(var_Items.AddItem("Mazda"),1,"ABS,ESP");
exontrol.EXTREELib.Column var_Column = extree1.Columns["Car"];
var_Column.FilterType = exontrol.EXTREELib.FilterTypeEnum.exFilter;
var_Column.Filter = "Mazda";
exontrol.EXTREELib.Column var_Column1 = extree1.Columns["Equipment"];
var_Column1.FilterType = exontrol.EXTREELib.FilterTypeEnum.exPattern;
var_Column1.Filter = "*ABS*|*ESP*";
extree1.ApplyFilter();
extree1.EndUpdate();
|
|
457
|
Is it possible to colour a particular column, I mean the cell's foreground color
extree1.BeginUpdate();
exontrol.EXTREELib.ConditionalFormat var_ConditionalFormat = extree1.ConditionalFormats.Add("1",null);
var_ConditionalFormat.ForeColor = Color.FromArgb(255,0,0);
var_ConditionalFormat.ApplyTo = (exontrol.EXTREELib.FormatApplyToEnum)0x1;
extree1.MarkSearchColumn = false;
exontrol.EXTREELib.Columns var_Columns = extree1.Columns;
var_Columns.Add("Column 1");
var_Columns.Add("Column 2");
exontrol.EXTREELib.Items var_Items = extree1.Items;
var_Items.set_CellCaption(var_Items.AddItem(0),1,1);
var_Items.set_CellCaption(var_Items.AddItem(2),1,3);
var_Items.set_CellCaption(var_Items.AddItem(4),1,5);
extree1.EndUpdate();
|
|
456
|
Is it possible to colour a particular column for specified values
extree1.BeginUpdate();
exontrol.EXTREELib.ConditionalFormat var_ConditionalFormat = extree1.ConditionalFormats.Add("int(%1) in (3,4,5)",null);
var_ConditionalFormat.BackColor = Color.FromArgb(255,0,0);
var_ConditionalFormat.ApplyTo = (exontrol.EXTREELib.FormatApplyToEnum)0x1;
extree1.MarkSearchColumn = false;
exontrol.EXTREELib.Columns var_Columns = extree1.Columns;
var_Columns.Add("Column 1");
var_Columns.Add("Column 2");
exontrol.EXTREELib.Items var_Items = extree1.Items;
var_Items.set_CellCaption(var_Items.AddItem(0),1,1);
var_Items.set_CellCaption(var_Items.AddItem(2),1,3);
var_Items.set_CellCaption(var_Items.AddItem(4),1,5);
extree1.EndUpdate();
|
|
455
|
Is it possible to colour a particular column
extree1.BeginUpdate();
extree1.MarkSearchColumn = false;
exontrol.EXTREELib.Columns var_Columns = extree1.Columns;
var_Columns.Add("Column 1");
(var_Columns.Add("Column 2") as exontrol.EXTREELib.Column).set_Def(exontrol.EXTREELib.DefColumnEnum.exCellBackColor,255);
exontrol.EXTREELib.Items var_Items = extree1.Items;
var_Items.set_CellCaption(var_Items.AddItem(0),1,1);
var_Items.set_CellCaption(var_Items.AddItem(2),1,3);
var_Items.set_CellCaption(var_Items.AddItem(4),1,5);
extree1.EndUpdate();
|
|
454
|
How do i get all the children items that are under a certain parent Item handle
extree1.BeginUpdate();
extree1.LinesAtRoot = exontrol.EXTREELib.LinesAtRootEnum.exLinesAtRoot;
extree1.Columns.Add("P");
exontrol.EXTREELib.Items var_Items = extree1.Items;
int h = var_Items.AddItem("Root");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(h,null,"Child 2");
var_Items.set_ExpandItem(h,true);
exontrol.EXTREELib.Items var_Items1 = extree1.Items;
int hChild = var_Items1.get_ItemChild(var_Items1.FirstVisibleItem);
System.Diagnostics.Debug.Print( var_Items1.get_CellCaption(hChild,0).ToString() );
System.Diagnostics.Debug.Print( var_Items1.get_CellCaption(var_Items1.get_NextSiblingItem(hChild),0).ToString() );
extree1.EndUpdate();
|
|
453
|
How can I get the caption of focused item
// SelectionChanged event - Fired after a new item has been selected.
private void extree1_SelectionChanged(object sender)
{
exontrol.EXTREELib.Items var_Items = extree1.Items;
System.Diagnostics.Debug.Print( "Handle" );
System.Diagnostics.Debug.Print( var_Items.FocusItem.ToString() );
System.Diagnostics.Debug.Print( "Caption" );
System.Diagnostics.Debug.Print( var_Items.get_CellCaption(var_Items.FocusItem,0).ToString() );
}
//this.extree1.SelectionChanged += new exontrol.EXTREELib.exg2antt.SelectionChangedEventHandler(this.extree1_SelectionChanged);
extree1.BeginUpdate();
extree1.LinesAtRoot = exontrol.EXTREELib.LinesAtRootEnum.exLinesAtRoot;
extree1.Columns.Add("Items");
exontrol.EXTREELib.Items var_Items = extree1.Items;
int h = var_Items.AddItem("R1");
var_Items.InsertItem(h,null,"Cell 1.1");
var_Items.InsertItem(h,null,"Cell 1.2");
var_Items.set_ExpandItem(h,true);
h = var_Items.AddItem("R2");
var_Items.InsertItem(h,null,"Cell 2.1");
var_Items.InsertItem(h,null,"Cell 2.2");
var_Items.set_ExpandItem(h,true);
extree1.EndUpdate();
|
|
452
|
How can I get the caption of selected item
// SelectionChanged event - Fired after a new item has been selected.
private void extree1_SelectionChanged(object sender)
{
exontrol.EXTREELib.Items var_Items = extree1.Items;
System.Diagnostics.Debug.Print( "Handle" );
System.Diagnostics.Debug.Print( var_Items.get_SelectedItem(0).ToString() );
System.Diagnostics.Debug.Print( "Caption" );
System.Diagnostics.Debug.Print( var_Items.get_CellCaption(var_Items.get_SelectedItem(0),0).ToString() );
}
//this.extree1.SelectionChanged += new exontrol.EXTREELib.exg2antt.SelectionChangedEventHandler(this.extree1_SelectionChanged);
extree1.BeginUpdate();
extree1.LinesAtRoot = exontrol.EXTREELib.LinesAtRootEnum.exLinesAtRoot;
extree1.Columns.Add("Items");
exontrol.EXTREELib.Items var_Items = extree1.Items;
int h = var_Items.AddItem("R1");
var_Items.InsertItem(h,null,"Cell 1.1");
var_Items.InsertItem(h,null,"Cell 1.2");
var_Items.set_ExpandItem(h,true);
h = var_Items.AddItem("R2");
var_Items.InsertItem(h,null,"Cell 2.1");
var_Items.InsertItem(h,null,"Cell 2.2");
var_Items.set_ExpandItem(h,true);
extree1.EndUpdate();
|
|
451
|
Can I display the cell's check box after the text
exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("Column") as exontrol.EXTREELib.Column);
var_Column.set_Def(exontrol.EXTREELib.DefColumnEnum.exCellHasCheckBox,true);
var_Column.set_Def(exontrol.EXTREELib.DefColumnEnum.exCellDrawPartsOrder,"caption,check");
exontrol.EXTREELib.Items var_Items = extree1.Items;
var_Items.set_CellHasCheckBox(var_Items.AddItem("Caption 1"),0,true);
var_Items.set_CellHasCheckBox(var_Items.AddItem("Caption 2"),0,true);
|
|
450
|
Can I change the order of the parts in the cell, as checkbox after the text, and so on
extree1.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" +
"lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" +
"0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" +
"NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=");
(extree1.Columns.Add("Column") as exontrol.EXTREELib.Column).set_Def(exontrol.EXTREELib.DefColumnEnum.exCellDrawPartsOrder,"caption,check,icon,icons,picture");
exontrol.EXTREELib.Items var_Items = extree1.Items;
int h = var_Items.AddItem("Text");
var_Items.set_CellImage(h,0,1);
var_Items.set_CellHasCheckBox(h,0,true);
|
|
449
|
Can I have an image displayed after the text. Can I get that effect without using HTML content
extree1.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" +
"lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" +
"0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" +
"NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=");
(extree1.Columns.Add("Column") as exontrol.EXTREELib.Column).set_Def(exontrol.EXTREELib.DefColumnEnum.exCellDrawPartsOrder,"caption,icon,check,icons,picture");
exontrol.EXTREELib.Items var_Items = extree1.Items;
int h = var_Items.AddItem("Text");
var_Items.set_CellImage(h,0,1);
|
|
448
|
Does your control support RightToLeft property for RTL languages or right to left
extree1.BeginUpdate();
extree1.ScrollBars = exontrol.EXTREELib.ScrollBarsEnum.exDisableBoth;
extree1.LinesAtRoot = exontrol.EXTREELib.LinesAtRootEnum.exLinesAtRoot;
exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("P1") as exontrol.EXTREELib.Column);
var_Column.set_Def(exontrol.EXTREELib.DefColumnEnum.exCellHasCheckBox,true);
var_Column.PartialCheck = true;
exontrol.EXTREELib.Items var_Items = extree1.Items;
int h = var_Items.AddItem("Root");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(h,null,"Child 2");
var_Items.set_ExpandItem(h,true);
extree1.RightToLeft = true;
extree1.EndUpdate();
|
|
447
|
Is there any way to display the vertical scroll bar on the left side, as I want to align my data to the right
extree1.BeginUpdate();
extree1.ScrollBars = exontrol.EXTREELib.ScrollBarsEnum.exDisableBoth;
exontrol.EXTREELib.Columns var_Columns = extree1.Columns;
var_Columns.Add("C1");
var_Columns.Add("C2");
var_Columns.Add("C3");
var_Columns.Add("C4");
var_Columns.Add("C5");
var_Columns.Add("C6");
var_Columns.Add("C7");
var_Columns.Add("C8");
extree1.RightToLeft = true;
extree1.EndUpdate();
|
|
446
|
How can I use the CASE statement (CASE usage)
extree1.BeginUpdate();
(extree1.Columns.Add("Value") as exontrol.EXTREELib.Column).Width = 24;
exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("CASE - statment") as exontrol.EXTREELib.Column);
var_Column.ComputedField = "%0 case (default:'not found';1:%0;2:2*%0;3:3*%0;4:4*%0;5:5*%0;7:'Seven';8:'Eight';9:'Nine';11:'Eleven';13:'Thirtheen';14:'Fourt" +
"heen')";
var_Column.ToolTip = var_Column.ComputedField;
exontrol.EXTREELib.Items var_Items = extree1.Items;
var_Items.AddItem(0);
var_Items.AddItem(1);
var_Items.AddItem(2);
extree1.EndUpdate();
|
|
445
|
How can I use the CASE statement (CASE usage)
extree1.BeginUpdate();
(extree1.Columns.Add("Value") as exontrol.EXTREELib.Column).Width = 24;
exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("CASE - statment") as exontrol.EXTREELib.Column);
var_Column.ComputedField = "%0 case (default:'not found';1:'One';2:'Two';3:'Three';4:'Four';5:'Five';7:'Seven';8:'Eight';9:'Nine';11:'Eleven';13:'Thirtheen" +
"';14:'Fourtheen')";
var_Column.ToolTip = var_Column.ComputedField;
exontrol.EXTREELib.Items var_Items = extree1.Items;
var_Items.AddItem(0);
var_Items.AddItem(1);
var_Items.AddItem(2);
extree1.EndUpdate();
|
|
444
|
I have seen the IN function but it returns -1 or 0. How can I display the value being found ( SWITCH usage )
extree1.BeginUpdate();
(extree1.Columns.Add("Value") as exontrol.EXTREELib.Column).Width = 24;
exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("SWITCH - statment") as exontrol.EXTREELib.Column);
var_Column.ComputedField = "%0 switch ('not found', 1,2,3,4,5,7,8,9,11,13,14)";
var_Column.ToolTip = var_Column.ComputedField;
exontrol.EXTREELib.Items var_Items = extree1.Items;
var_Items.AddItem(0);
var_Items.AddItem(1);
var_Items.AddItem(2);
extree1.EndUpdate();
|
|
443
|
I have a large collection of constant values and using or operator is a time consuming (IN usage). Is there any way to increase the speed to check if a value maches the collection
extree1.BeginUpdate();
(extree1.Columns.Add("Value") as exontrol.EXTREELib.Column).Width = 24;
exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("IN - statment") as exontrol.EXTREELib.Column);
var_Column.ComputedField = "%0 in (1,2,3,4,5,7,8,9,11,13,14) ? 'found' : ''";
var_Column.ToolTip = var_Column.ComputedField;
exontrol.EXTREELib.Items var_Items = extree1.Items;
var_Items.AddItem(0);
var_Items.AddItem(1);
var_Items.AddItem(2);
extree1.EndUpdate();
|
|
442
|
Is is possible to use HTML tags to display in the filter caption
extree1.BeginUpdate();
extree1.FilterBarPromptVisible = true;
extree1.FilterBarCaption = "This is a bit of text being displayed in the filter bar.";
extree1.Columns.Add("");
exontrol.EXTREELib.Items var_Items = extree1.Items;
var_Items.AddItem("Item 1");
var_Items.AddItem("Item 2");
var_Items.AddItem("Item 3");
extree1.EndUpdate();
|
|
441
|
How can I find the number of items after filtering
extree1.BeginUpdate();
extree1.Columns.Add("");
exontrol.EXTREELib.Items var_Items = extree1.Items;
int h = var_Items.AddItem("");
var_Items.set_CellCaption(h,0,var_Items.VisibleItemCount);
extree1.EndUpdate();
|
|
440
|
How can I change the filter caption
extree1.BeginUpdate();
extree1.ColumnAutoResize = true;
extree1.ContinueColumnScroll = false;
extree1.MarkSearchColumn = false;
extree1.SearchColumnIndex = 1;
extree1.FilterBarPromptVisible = true;
extree1.FilterBarPromptType = exontrol.EXTREELib.FilterPromptEnum.exFilterPromptWords | exontrol.EXTREELib.FilterPromptEnum.exFilterPromptContainsAll;
extree1.FilterBarPromptPattern = "london robert";
extree1.FilterBarCaption = "<r>Found: ... ";
exontrol.EXTREELib.Columns var_Columns = extree1.Columns;
(var_Columns.Add("Name") as exontrol.EXTREELib.Column).Width = 96;
(var_Columns.Add("Title") as exontrol.EXTREELib.Column).Width = 96;
var_Columns.Add("City");
exontrol.EXTREELib.Items var_Items = extree1.Items;
int h0 = var_Items.AddItem("Nancy Davolio");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Seattle");
h0 = var_Items.AddItem("Andrew Fuller");
var_Items.set_CellCaption(h0,1,"Vice President, Sales");
var_Items.set_CellCaption(h0,2,"Tacoma");
var_Items.set_SelectItem(h0,true);
h0 = var_Items.AddItem("Janet Leverling");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Kirkland");
h0 = var_Items.AddItem("Margaret Peacock");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Redmond");
h0 = var_Items.AddItem("Steven Buchanan");
var_Items.set_CellCaption(h0,1,"Sales Manager");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Michael Suyama");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Robert King");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Laura Callahan");
var_Items.set_CellCaption(h0,1,"Inside Sales Coordinator");
var_Items.set_CellCaption(h0,2,"Seattle");
h0 = var_Items.AddItem("Anne Dodsworth");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
extree1.EndUpdate();
|
|
439
|
While using the filter prompt is it is possible to use wild characters
extree1.BeginUpdate();
extree1.ColumnAutoResize = true;
extree1.ContinueColumnScroll = false;
extree1.MarkSearchColumn = false;
extree1.SearchColumnIndex = 1;
extree1.FilterBarPromptVisible = true;
extree1.FilterBarPromptType = exontrol.EXTREELib.FilterPromptEnum.exFilterPromptPattern;
extree1.FilterBarPromptPattern = "lon* seat*";
exontrol.EXTREELib.Columns var_Columns = extree1.Columns;
(var_Columns.Add("Name") as exontrol.EXTREELib.Column).Width = 96;
(var_Columns.Add("Title") as exontrol.EXTREELib.Column).Width = 96;
var_Columns.Add("City");
exontrol.EXTREELib.Items var_Items = extree1.Items;
int h0 = var_Items.AddItem("Nancy Davolio");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Seattle");
h0 = var_Items.AddItem("Andrew Fuller");
var_Items.set_CellCaption(h0,1,"Vice President, Sales");
var_Items.set_CellCaption(h0,2,"Tacoma");
var_Items.set_SelectItem(h0,true);
h0 = var_Items.AddItem("Janet Leverling");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Kirkland");
h0 = var_Items.AddItem("Margaret Peacock");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Redmond");
h0 = var_Items.AddItem("Steven Buchanan");
var_Items.set_CellCaption(h0,1,"Sales Manager");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Michael Suyama");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Robert King");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Laura Callahan");
var_Items.set_CellCaption(h0,1,"Inside Sales Coordinator");
var_Items.set_CellCaption(h0,2,"Seattle");
h0 = var_Items.AddItem("Anne Dodsworth");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
extree1.EndUpdate();
|
|
438
|
How can I list all items that contains any of specified words, not necessary at the beggining
extree1.BeginUpdate();
extree1.ColumnAutoResize = true;
extree1.ContinueColumnScroll = false;
extree1.MarkSearchColumn = false;
extree1.SearchColumnIndex = 1;
extree1.FilterBarPromptVisible = true;
extree1.FilterBarPromptType = exontrol.EXTREELib.FilterPromptEnum.exFilterPromptStartWords | exontrol.EXTREELib.FilterPromptEnum.exFilterPromptContainsAny;
extree1.FilterBarPromptPattern = "london davolio";
exontrol.EXTREELib.Columns var_Columns = extree1.Columns;
(var_Columns.Add("Name") as exontrol.EXTREELib.Column).Width = 96;
(var_Columns.Add("Title") as exontrol.EXTREELib.Column).Width = 96;
var_Columns.Add("City");
exontrol.EXTREELib.Items var_Items = extree1.Items;
int h0 = var_Items.AddItem("Nancy Davolio");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Seattle");
h0 = var_Items.AddItem("Andrew Fuller");
var_Items.set_CellCaption(h0,1,"Vice President, Sales");
var_Items.set_CellCaption(h0,2,"Tacoma");
var_Items.set_SelectItem(h0,true);
h0 = var_Items.AddItem("Janet Leverling");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Kirkland");
h0 = var_Items.AddItem("Margaret Peacock");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Redmond");
h0 = var_Items.AddItem("Steven Buchanan");
var_Items.set_CellCaption(h0,1,"Sales Manager");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Michael Suyama");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Robert King");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Laura Callahan");
var_Items.set_CellCaption(h0,1,"Inside Sales Coordinator");
var_Items.set_CellCaption(h0,2,"Seattle");
h0 = var_Items.AddItem("Anne Dodsworth");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
extree1.EndUpdate();
|
|
437
|
How can I list all items that contains any of specified words, not strings
extree1.BeginUpdate();
extree1.ColumnAutoResize = true;
extree1.ContinueColumnScroll = false;
extree1.MarkSearchColumn = false;
extree1.SearchColumnIndex = 1;
extree1.FilterBarPromptVisible = true;
extree1.FilterBarPromptType = exontrol.EXTREELib.FilterPromptEnum.exFilterPromptWords | exontrol.EXTREELib.FilterPromptEnum.exFilterPromptContainsAny;
extree1.FilterBarPromptPattern = "london nancy";
exontrol.EXTREELib.Columns var_Columns = extree1.Columns;
(var_Columns.Add("Name") as exontrol.EXTREELib.Column).Width = 96;
(var_Columns.Add("Title") as exontrol.EXTREELib.Column).Width = 96;
var_Columns.Add("City");
exontrol.EXTREELib.Items var_Items = extree1.Items;
int h0 = var_Items.AddItem("Nancy Davolio");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Seattle");
h0 = var_Items.AddItem("Andrew Fuller");
var_Items.set_CellCaption(h0,1,"Vice President, Sales");
var_Items.set_CellCaption(h0,2,"Tacoma");
var_Items.set_SelectItem(h0,true);
h0 = var_Items.AddItem("Janet Leverling");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Kirkland");
h0 = var_Items.AddItem("Margaret Peacock");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Redmond");
h0 = var_Items.AddItem("Steven Buchanan");
var_Items.set_CellCaption(h0,1,"Sales Manager");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Michael Suyama");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Robert King");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Laura Callahan");
var_Items.set_CellCaption(h0,1,"Inside Sales Coordinator");
var_Items.set_CellCaption(h0,2,"Seattle");
h0 = var_Items.AddItem("Anne Dodsworth");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
extree1.EndUpdate();
|
|
436
|
How can I list all items that contains all specified words, not strings
extree1.BeginUpdate();
extree1.ColumnAutoResize = true;
extree1.ContinueColumnScroll = false;
extree1.MarkSearchColumn = false;
extree1.SearchColumnIndex = 1;
extree1.FilterBarPromptVisible = true;
extree1.FilterBarPromptType = exontrol.EXTREELib.FilterPromptEnum.exFilterPromptWords | exontrol.EXTREELib.FilterPromptEnum.exFilterPromptContainsAll;
extree1.FilterBarPromptPattern = "london robert";
exontrol.EXTREELib.Columns var_Columns = extree1.Columns;
(var_Columns.Add("Name") as exontrol.EXTREELib.Column).Width = 96;
(var_Columns.Add("Title") as exontrol.EXTREELib.Column).Width = 96;
var_Columns.Add("City");
exontrol.EXTREELib.Items var_Items = extree1.Items;
int h0 = var_Items.AddItem("Nancy Davolio");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Seattle");
h0 = var_Items.AddItem("Andrew Fuller");
var_Items.set_CellCaption(h0,1,"Vice President, Sales");
var_Items.set_CellCaption(h0,2,"Tacoma");
var_Items.set_SelectItem(h0,true);
h0 = var_Items.AddItem("Janet Leverling");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Kirkland");
h0 = var_Items.AddItem("Margaret Peacock");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Redmond");
h0 = var_Items.AddItem("Steven Buchanan");
var_Items.set_CellCaption(h0,1,"Sales Manager");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Michael Suyama");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Robert King");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Laura Callahan");
var_Items.set_CellCaption(h0,1,"Inside Sales Coordinator");
var_Items.set_CellCaption(h0,2,"Seattle");
h0 = var_Items.AddItem("Anne Dodsworth");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
extree1.EndUpdate();
|
|
435
|
I've noticed that the filtering by prompt is not case sensitive, is is possible to make it case sensitive
extree1.BeginUpdate();
extree1.ColumnAutoResize = true;
extree1.ContinueColumnScroll = false;
extree1.MarkSearchColumn = false;
extree1.SearchColumnIndex = 1;
extree1.FilterBarPromptVisible = true;
extree1.FilterBarPromptType = exontrol.EXTREELib.FilterPromptEnum.exFilterPromptCaseSensitive | exontrol.EXTREELib.FilterPromptEnum.exFilterPromptContainsAny;
extree1.FilterBarPromptPattern = "Anne";
exontrol.EXTREELib.Columns var_Columns = extree1.Columns;
(var_Columns.Add("Name") as exontrol.EXTREELib.Column).Width = 96;
(var_Columns.Add("Title") as exontrol.EXTREELib.Column).Width = 96;
var_Columns.Add("City");
exontrol.EXTREELib.Items var_Items = extree1.Items;
int h0 = var_Items.AddItem("Nancy Davolio");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Seattle");
h0 = var_Items.AddItem("Andrew Fuller");
var_Items.set_CellCaption(h0,1,"Vice President, Sales");
var_Items.set_CellCaption(h0,2,"Tacoma");
var_Items.set_SelectItem(h0,true);
h0 = var_Items.AddItem("Janet Leverling");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Kirkland");
h0 = var_Items.AddItem("Margaret Peacock");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Redmond");
h0 = var_Items.AddItem("Steven Buchanan");
var_Items.set_CellCaption(h0,1,"Sales Manager");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Michael Suyama");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Robert King");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Laura Callahan");
var_Items.set_CellCaption(h0,1,"Inside Sales Coordinator");
var_Items.set_CellCaption(h0,2,"Seattle");
h0 = var_Items.AddItem("Anne Dodsworth");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
extree1.EndUpdate();
|
|
434
|
Is it possible to list only items that ends with any of specified strings
extree1.BeginUpdate();
extree1.ColumnAutoResize = true;
extree1.ContinueColumnScroll = false;
extree1.MarkSearchColumn = false;
extree1.SearchColumnIndex = 1;
extree1.FilterBarPromptVisible = true;
extree1.FilterBarPromptType = exontrol.EXTREELib.FilterPromptEnum.exFilterPromptEndWith;
extree1.FilterBarPromptColumns = "0";
extree1.FilterBarPromptPattern = "Fuller";
exontrol.EXTREELib.Columns var_Columns = extree1.Columns;
(var_Columns.Add("Name") as exontrol.EXTREELib.Column).Width = 96;
(var_Columns.Add("Title") as exontrol.EXTREELib.Column).Width = 96;
var_Columns.Add("City");
exontrol.EXTREELib.Items var_Items = extree1.Items;
int h0 = var_Items.AddItem("Nancy Davolio");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Seattle");
h0 = var_Items.AddItem("Andrew Fuller");
var_Items.set_CellCaption(h0,1,"Vice President, Sales");
var_Items.set_CellCaption(h0,2,"Tacoma");
var_Items.set_SelectItem(h0,true);
h0 = var_Items.AddItem("Janet Leverling");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Kirkland");
h0 = var_Items.AddItem("Margaret Peacock");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Redmond");
h0 = var_Items.AddItem("Steven Buchanan");
var_Items.set_CellCaption(h0,1,"Sales Manager");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Michael Suyama");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Robert King");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Laura Callahan");
var_Items.set_CellCaption(h0,1,"Inside Sales Coordinator");
var_Items.set_CellCaption(h0,2,"Seattle");
h0 = var_Items.AddItem("Anne Dodsworth");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
extree1.EndUpdate();
|
|
433
|
Is it possible to list only items that ends with any of specified strings
extree1.BeginUpdate();
extree1.ColumnAutoResize = true;
extree1.ContinueColumnScroll = false;
extree1.MarkSearchColumn = false;
extree1.SearchColumnIndex = 1;
extree1.FilterBarPromptVisible = true;
extree1.FilterBarPromptType = exontrol.EXTREELib.FilterPromptEnum.exFilterPromptEndWith;
extree1.FilterBarPromptColumns = "0";
extree1.FilterBarPromptPattern = "Fuller";
exontrol.EXTREELib.Columns var_Columns = extree1.Columns;
(var_Columns.Add("Name") as exontrol.EXTREELib.Column).Width = 96;
(var_Columns.Add("Title") as exontrol.EXTREELib.Column).Width = 96;
var_Columns.Add("City");
exontrol.EXTREELib.Items var_Items = extree1.Items;
int h0 = var_Items.AddItem("Nancy Davolio");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Seattle");
h0 = var_Items.AddItem("Andrew Fuller");
var_Items.set_CellCaption(h0,1,"Vice President, Sales");
var_Items.set_CellCaption(h0,2,"Tacoma");
var_Items.set_SelectItem(h0,true);
h0 = var_Items.AddItem("Janet Leverling");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Kirkland");
h0 = var_Items.AddItem("Margaret Peacock");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Redmond");
h0 = var_Items.AddItem("Steven Buchanan");
var_Items.set_CellCaption(h0,1,"Sales Manager");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Michael Suyama");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Robert King");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Laura Callahan");
var_Items.set_CellCaption(h0,1,"Inside Sales Coordinator");
var_Items.set_CellCaption(h0,2,"Seattle");
h0 = var_Items.AddItem("Anne Dodsworth");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
extree1.EndUpdate();
|
|
432
|
Is it possible to list only items that starts with any of specified strings
extree1.BeginUpdate();
extree1.ColumnAutoResize = true;
extree1.ContinueColumnScroll = false;
extree1.MarkSearchColumn = false;
extree1.SearchColumnIndex = 1;
extree1.FilterBarPromptVisible = true;
extree1.FilterBarPromptType = exontrol.EXTREELib.FilterPromptEnum.exFilterPromptStartWith;
extree1.FilterBarPromptColumns = "0";
extree1.FilterBarPromptPattern = "An M";
exontrol.EXTREELib.Columns var_Columns = extree1.Columns;
(var_Columns.Add("Name") as exontrol.EXTREELib.Column).Width = 96;
(var_Columns.Add("Title") as exontrol.EXTREELib.Column).Width = 96;
var_Columns.Add("City");
exontrol.EXTREELib.Items var_Items = extree1.Items;
int h0 = var_Items.AddItem("Nancy Davolio");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Seattle");
h0 = var_Items.AddItem("Andrew Fuller");
var_Items.set_CellCaption(h0,1,"Vice President, Sales");
var_Items.set_CellCaption(h0,2,"Tacoma");
var_Items.set_SelectItem(h0,true);
h0 = var_Items.AddItem("Janet Leverling");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Kirkland");
h0 = var_Items.AddItem("Margaret Peacock");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Redmond");
h0 = var_Items.AddItem("Steven Buchanan");
var_Items.set_CellCaption(h0,1,"Sales Manager");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Michael Suyama");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Robert King");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Laura Callahan");
var_Items.set_CellCaption(h0,1,"Inside Sales Coordinator");
var_Items.set_CellCaption(h0,2,"Seattle");
h0 = var_Items.AddItem("Anne Dodsworth");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
extree1.EndUpdate();
|
|
431
|
Is it possible to list only items that starts with specified string
extree1.BeginUpdate();
extree1.ColumnAutoResize = true;
extree1.ContinueColumnScroll = false;
extree1.MarkSearchColumn = false;
extree1.SearchColumnIndex = 1;
extree1.FilterBarPromptVisible = true;
extree1.FilterBarPromptType = exontrol.EXTREELib.FilterPromptEnum.exFilterPromptStartWith;
extree1.FilterBarPromptColumns = "0";
extree1.FilterBarPromptPattern = "A";
exontrol.EXTREELib.Columns var_Columns = extree1.Columns;
(var_Columns.Add("Name") as exontrol.EXTREELib.Column).Width = 96;
(var_Columns.Add("Title") as exontrol.EXTREELib.Column).Width = 96;
var_Columns.Add("City");
exontrol.EXTREELib.Items var_Items = extree1.Items;
int h0 = var_Items.AddItem("Nancy Davolio");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Seattle");
h0 = var_Items.AddItem("Andrew Fuller");
var_Items.set_CellCaption(h0,1,"Vice President, Sales");
var_Items.set_CellCaption(h0,2,"Tacoma");
var_Items.set_SelectItem(h0,true);
h0 = var_Items.AddItem("Janet Leverling");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Kirkland");
h0 = var_Items.AddItem("Margaret Peacock");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Redmond");
h0 = var_Items.AddItem("Steven Buchanan");
var_Items.set_CellCaption(h0,1,"Sales Manager");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Michael Suyama");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Robert King");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Laura Callahan");
var_Items.set_CellCaption(h0,1,"Inside Sales Coordinator");
var_Items.set_CellCaption(h0,2,"Seattle");
h0 = var_Items.AddItem("Anne Dodsworth");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
extree1.EndUpdate();
|
|
430
|
How can I specify that the list should include any of the seqeunces in the pattern
extree1.BeginUpdate();
extree1.ColumnAutoResize = true;
extree1.ContinueColumnScroll = false;
extree1.MarkSearchColumn = false;
extree1.SearchColumnIndex = 1;
extree1.FilterBarPromptVisible = true;
extree1.FilterBarPromptType = exontrol.EXTREELib.FilterPromptEnum.exFilterPromptContainsAny;
extree1.FilterBarPromptPattern = "london seattle";
exontrol.EXTREELib.Columns var_Columns = extree1.Columns;
(var_Columns.Add("Name") as exontrol.EXTREELib.Column).Width = 96;
(var_Columns.Add("Title") as exontrol.EXTREELib.Column).Width = 96;
var_Columns.Add("City");
exontrol.EXTREELib.Items var_Items = extree1.Items;
int h0 = var_Items.AddItem("Nancy Davolio");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Seattle");
h0 = var_Items.AddItem("Andrew Fuller");
var_Items.set_CellCaption(h0,1,"Vice President, Sales");
var_Items.set_CellCaption(h0,2,"Tacoma");
var_Items.set_SelectItem(h0,true);
h0 = var_Items.AddItem("Janet Leverling");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Kirkland");
h0 = var_Items.AddItem("Margaret Peacock");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Redmond");
h0 = var_Items.AddItem("Steven Buchanan");
var_Items.set_CellCaption(h0,1,"Sales Manager");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Michael Suyama");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Robert King");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Laura Callahan");
var_Items.set_CellCaption(h0,1,"Inside Sales Coordinator");
var_Items.set_CellCaption(h0,2,"Seattle");
h0 = var_Items.AddItem("Anne Dodsworth");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
extree1.EndUpdate();
|
|
429
|
How can I specify that all sequences in the filter pattern must be included in the list
extree1.BeginUpdate();
extree1.ColumnAutoResize = true;
extree1.ContinueColumnScroll = false;
extree1.MarkSearchColumn = false;
extree1.SearchColumnIndex = 1;
extree1.FilterBarPromptVisible = true;
extree1.FilterBarPromptType = exontrol.EXTREELib.FilterPromptEnum.exFilterPromptContainsAll;
extree1.FilterBarPromptPattern = "london manager";
exontrol.EXTREELib.Columns var_Columns = extree1.Columns;
(var_Columns.Add("Name") as exontrol.EXTREELib.Column).Width = 96;
(var_Columns.Add("Title") as exontrol.EXTREELib.Column).Width = 96;
var_Columns.Add("City");
exontrol.EXTREELib.Items var_Items = extree1.Items;
int h0 = var_Items.AddItem("Nancy Davolio");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Seattle");
h0 = var_Items.AddItem("Andrew Fuller");
var_Items.set_CellCaption(h0,1,"Vice President, Sales");
var_Items.set_CellCaption(h0,2,"Tacoma");
var_Items.set_SelectItem(h0,true);
h0 = var_Items.AddItem("Janet Leverling");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Kirkland");
h0 = var_Items.AddItem("Margaret Peacock");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Redmond");
h0 = var_Items.AddItem("Steven Buchanan");
var_Items.set_CellCaption(h0,1,"Sales Manager");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Michael Suyama");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Robert King");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Laura Callahan");
var_Items.set_CellCaption(h0,1,"Inside Sales Coordinator");
var_Items.set_CellCaption(h0,2,"Seattle");
h0 = var_Items.AddItem("Anne Dodsworth");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
extree1.EndUpdate();
|
|
428
|
How do I change at runtime the filter prompt
extree1.BeginUpdate();
extree1.ColumnAutoResize = true;
extree1.ContinueColumnScroll = false;
extree1.MarkSearchColumn = false;
extree1.SearchColumnIndex = 1;
extree1.FilterBarPromptVisible = true;
extree1.FilterBarPromptPattern = "london manager";
exontrol.EXTREELib.Columns var_Columns = extree1.Columns;
(var_Columns.Add("Name") as exontrol.EXTREELib.Column).Width = 96;
(var_Columns.Add("Title") as exontrol.EXTREELib.Column).Width = 96;
var_Columns.Add("City");
exontrol.EXTREELib.Items var_Items = extree1.Items;
int h0 = var_Items.AddItem("Nancy Davolio");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Seattle");
h0 = var_Items.AddItem("Andrew Fuller");
var_Items.set_CellCaption(h0,1,"Vice President, Sales");
var_Items.set_CellCaption(h0,2,"Tacoma");
var_Items.set_SelectItem(h0,true);
h0 = var_Items.AddItem("Janet Leverling");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Kirkland");
h0 = var_Items.AddItem("Margaret Peacock");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Redmond");
h0 = var_Items.AddItem("Steven Buchanan");
var_Items.set_CellCaption(h0,1,"Sales Manager");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Michael Suyama");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Robert King");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Laura Callahan");
var_Items.set_CellCaption(h0,1,"Inside Sales Coordinator");
var_Items.set_CellCaption(h0,2,"Seattle");
h0 = var_Items.AddItem("Anne Dodsworth");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
extree1.EndUpdate();
|
|
427
|
How do I specify to filter only a single column when using the filter prompt
extree1.BeginUpdate();
extree1.ColumnAutoResize = true;
extree1.ContinueColumnScroll = false;
extree1.MarkSearchColumn = false;
extree1.SearchColumnIndex = 1;
extree1.FilterBarPromptVisible = true;
extree1.FilterBarPromptColumns = "2,3";
extree1.FilterBarPromptPattern = "london";
exontrol.EXTREELib.Columns var_Columns = extree1.Columns;
(var_Columns.Add("Name") as exontrol.EXTREELib.Column).Width = 96;
(var_Columns.Add("Title") as exontrol.EXTREELib.Column).Width = 96;
var_Columns.Add("City");
exontrol.EXTREELib.Items var_Items = extree1.Items;
int h0 = var_Items.AddItem("Nancy Davolio");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Seattle");
h0 = var_Items.AddItem("Andrew Fuller");
var_Items.set_CellCaption(h0,1,"Vice President, Sales");
var_Items.set_CellCaption(h0,2,"Tacoma");
var_Items.set_SelectItem(h0,true);
h0 = var_Items.AddItem("Janet Leverling");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Kirkland");
h0 = var_Items.AddItem("Margaret Peacock");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Redmond");
h0 = var_Items.AddItem("Steven Buchanan");
var_Items.set_CellCaption(h0,1,"Sales Manager");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Michael Suyama");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Robert King");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Laura Callahan");
var_Items.set_CellCaption(h0,1,"Inside Sales Coordinator");
var_Items.set_CellCaption(h0,2,"Seattle");
h0 = var_Items.AddItem("Anne Dodsworth");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
extree1.EndUpdate();
|
|
426
|
How do I change the prompt or the caption being displayed in the filter bar
extree1.BeginUpdate();
extree1.ColumnAutoResize = true;
extree1.ContinueColumnScroll = false;
extree1.MarkSearchColumn = false;
extree1.SearchColumnIndex = 1;
extree1.FilterBarPromptVisible = true;
extree1.FilterBarPrompt = "changed";
exontrol.EXTREELib.Columns var_Columns = extree1.Columns;
(var_Columns.Add("Name") as exontrol.EXTREELib.Column).Width = 96;
(var_Columns.Add("Title") as exontrol.EXTREELib.Column).Width = 96;
var_Columns.Add("City");
extree1.EndUpdate();
|
|
425
|
How do I enable the filter prompt feature
extree1.BeginUpdate();
extree1.ColumnAutoResize = true;
extree1.ContinueColumnScroll = false;
extree1.MarkSearchColumn = false;
extree1.SearchColumnIndex = 1;
extree1.FilterBarPromptVisible = true;
exontrol.EXTREELib.Columns var_Columns = extree1.Columns;
(var_Columns.Add("Name") as exontrol.EXTREELib.Column).Width = 96;
(var_Columns.Add("Title") as exontrol.EXTREELib.Column).Width = 96;
var_Columns.Add("City");
exontrol.EXTREELib.Items var_Items = extree1.Items;
int h0 = var_Items.AddItem("Nancy Davolio");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Seattle");
h0 = var_Items.AddItem("Andrew Fuller");
var_Items.set_CellCaption(h0,1,"Vice President, Sales");
var_Items.set_CellCaption(h0,2,"Tacoma");
var_Items.set_SelectItem(h0,true);
h0 = var_Items.AddItem("Janet Leverling");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Kirkland");
h0 = var_Items.AddItem("Margaret Peacock");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Redmond");
h0 = var_Items.AddItem("Steven Buchanan");
var_Items.set_CellCaption(h0,1,"Sales Manager");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Michael Suyama");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Robert King");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Laura Callahan");
var_Items.set_CellCaption(h0,1,"Inside Sales Coordinator");
var_Items.set_CellCaption(h0,2,"Seattle");
h0 = var_Items.AddItem("Anne Dodsworth");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
extree1.EndUpdate();
|
|
424
|
I have an EBN file how can I apply different colors to it, so no need to create a new one
extree1.VisualAppearance.Add(1,"c:\\exontrol\\images\\normal.ebn");
extree1.SelBackColor = extree1.BackColor;
extree1.SelForeColor = extree1.ForeColor;
extree1.HasLines = exontrol.EXTREELib.HierarchyLineEnum.exNoLine;
extree1.Columns.Add("Default");
exontrol.EXTREELib.Items var_Items = extree1.Items;
int h = var_Items.AddItem("Root");
int hC = var_Items.InsertItem(h,null,"Default");
var_Items.set_ItemBackColor32(hC,0x1000000);
var_Items.set_ItemHeight(var_Items.InsertItem(h,null,""),6);
hC = var_Items.InsertItem(h,null,"Light Green");
var_Items.set_ItemBackColor32(hC,0x100ff00);
var_Items.set_ItemHeight(var_Items.InsertItem(h,null,""),6);
hC = var_Items.InsertItem(h,null,"Dark Green");
var_Items.set_ItemBackColor32(hC,0x1007f00);
var_Items.set_ItemHeight(var_Items.InsertItem(h,null,""),6);
hC = var_Items.InsertItem(h,null,"Magenta");
var_Items.set_ItemBackColor32(hC,0x1ff7fff);
var_Items.set_ItemHeight(var_Items.InsertItem(h,null,""),6);
hC = var_Items.InsertItem(h,null,"Yellow");
var_Items.set_ItemBackColor32(hC,0x17fffff);
var_Items.set_ItemHeight(var_Items.InsertItem(h,null,""),6);
var_Items.set_ExpandItem(h,true);
|
|
423
|
How can I change the foreground color for a particular column
exontrol.EXTREELib.Columns var_Columns = extree1.Columns;
var_Columns.Add("Column 1");
(var_Columns.Add("Column 2") as exontrol.EXTREELib.Column).set_Def(exontrol.EXTREELib.DefColumnEnum.exHeaderForeColor,8439039);
var_Columns.Add("Column 3");
|
|
422
|
How can I change the background color for a particular column
exontrol.EXTREELib.Columns var_Columns = extree1.Columns;
var_Columns.Add("Column 1");
(var_Columns.Add("Column 2") as exontrol.EXTREELib.Column).set_Def(exontrol.EXTREELib.DefColumnEnum.exHeaderBackColor,8439039);
var_Columns.Add("Column 3");
|
|
421
|
How can I display the column using currency format and enlarge the font for certain values
exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("Currency") as exontrol.EXTREELib.Column);
var_Column.set_Def(exontrol.EXTREELib.DefColumnEnum.exCellCaptionFormat,1);
var_Column.FormatColumn = "len(value) ? ((0:=dbl(value)) < 10 ? '<fgcolor=808080><font ;7>' : '<b>') + currency(=:0)";
exontrol.EXTREELib.Items var_Items = extree1.Items;
var_Items.AddItem("1.23");
var_Items.AddItem("2.34");
var_Items.AddItem("9.94");
var_Items.AddItem("11.94");
var_Items.AddItem("1000");
|
|
420
|
How can I highlight only parts of the cells
exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("") as exontrol.EXTREELib.Column);
var_Column.set_Def(exontrol.EXTREELib.DefColumnEnum.exCellCaptionFormat,1);
var_Column.FormatColumn = "value replace 'hil' with '<fgcolor=FF0000><b>hil</b></fgcolor>'";
exontrol.EXTREELib.Items var_Items = extree1.Items;
int h = var_Items.AddItem("Root");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(h,null,"Child 2");
var_Items.InsertItem(h,null,"Child 3");
var_Items.set_ExpandItem(h,true);
|
|
419
|
How can I get the number of occurrences of a specified string in the cell
extree1.Columns.Add("");
exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("occurrences") as exontrol.EXTREELib.Column);
var_Column.ComputedField = "lower(%0) count 'o'";
var_Column.FormatColumn = "'contains ' + value + ' of \\'o\\' chars'";
exontrol.EXTREELib.Items var_Items = extree1.Items;
int h = var_Items.AddItem("Root");
var_Items.InsertItem(h,null,"Child 1 oooof the root");
var_Items.InsertItem(h,null,"Child 2");
var_Items.InsertItem(h,null,"Child 3");
var_Items.set_ExpandItem(h,true);
|
|
418
|
How can I display dates in my format
exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("Date") as exontrol.EXTREELib.Column);
var_Column.set_Def(exontrol.EXTREELib.DefColumnEnum.exCellCaptionFormat,1);
var_Column.FormatColumn = "'<b>' + year(0:=date(value)) + '</b><fgcolor=808080><font ;6> (' + month(=:0) + ' - ' + day(=:0) +')'";
exontrol.EXTREELib.Items var_Items = extree1.Items;
var_Items.AddItem(Convert.ToDateTime("1/21/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("2/22/2002",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("3/13/2003",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("4/24/2004",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
|
|
417
|
How can I display dates in short format
(extree1.Columns.Add("Date") as exontrol.EXTREELib.Column).FormatColumn = "shortdate(value)";
exontrol.EXTREELib.Items var_Items = extree1.Items;
var_Items.AddItem(Convert.ToDateTime("1/1/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("2/2/2002",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("3/3/2003",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("4/4/2004",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
|
|
416
|
How can I display dates in long format
(extree1.Columns.Add("Date") as exontrol.EXTREELib.Column).FormatColumn = "longdate(value)";
exontrol.EXTREELib.Items var_Items = extree1.Items;
var_Items.AddItem(Convert.ToDateTime("1/1/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("2/2/2002",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("3/3/2003",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("4/4/2004",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
|
|
415
|
How can I display only the right part of the cell
extree1.Columns.Add("");
exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("Right") as exontrol.EXTREELib.Column);
var_Column.ComputedField = "%0 right 2";
var_Column.FormatColumn = "'\"' + value + '\"'";
exontrol.EXTREELib.Items var_Items = extree1.Items;
int h = var_Items.AddItem("Root");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(h,null,"Child 2");
var_Items.InsertItem(h,null,"SChild 3");
var_Items.set_ExpandItem(h,true);
|
|
414
|
How can I display only the left part of the cell
extree1.Columns.Add("");
(extree1.Columns.Add("Left") as exontrol.EXTREELib.Column).ComputedField = "%0 left 2";
exontrol.EXTREELib.Items var_Items = extree1.Items;
int h = var_Items.AddItem("Root");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(h,null,"Child 2");
var_Items.InsertItem(h,null,"SChild 3");
var_Items.set_ExpandItem(h,true);
|
|
413
|
How can I display true or false instead 0 and -1
(extree1.Columns.Add("Boolean") as exontrol.EXTREELib.Column).FormatColumn = "value != 0 ? 'true' : 'false'";
exontrol.EXTREELib.Items var_Items = extree1.Items;
var_Items.AddItem(true);
var_Items.AddItem(false);
var_Items.AddItem(true);
var_Items.AddItem(0);
var_Items.AddItem(1);
|
|
412
|
How can I display icons or images instead numbers
extree1.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" +
"lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" +
"0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" +
"NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=");
exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("Icons") as exontrol.EXTREELib.Column);
var_Column.set_Def(exontrol.EXTREELib.DefColumnEnum.exCellCaptionFormat,1);
var_Column.FormatColumn = "'The cell displays the icon <img>'+value+'</img> instead ' + value";
exontrol.EXTREELib.Items var_Items = extree1.Items;
var_Items.AddItem(1);
var_Items.AddItem(2);
var_Items.AddItem(3);
|
|
411
|
How can I display the column using currency
(extree1.Columns.Add("Currency") as exontrol.EXTREELib.Column).FormatColumn = "currency(dbl(value))";
exontrol.EXTREELib.Items var_Items = extree1.Items;
var_Items.AddItem("1.23");
var_Items.AddItem("2.34");
var_Items.AddItem("0");
var_Items.AddItem(5);
var_Items.AddItem("10000.99");
|
|
410
|
How can I display the currency only for not empty cells
extree1.Columns.Add("Number");
(extree1.Columns.Add("Currency") as exontrol.EXTREELib.Column).ComputedField = "len(%0) ? currency(dbl(%0)) : ''";
exontrol.EXTREELib.Items var_Items = extree1.Items;
var_Items.AddItem("1.23");
var_Items.AddItem("2.34");
var_Items.AddItem("0");
var_Items.set_ItemBackColor(var_Items.AddItem(null),Color.FromArgb(255,128,128));
var_Items.AddItem("10000.99");
|
|
409
|
Is there a function to display the number of days between two date including the number of hours
(extree1.Columns.Add("Start") as exontrol.EXTREELib.Column).Width = 32;
extree1.Columns.Add("End");
(extree1.Columns.Add("Duration") as exontrol.EXTREELib.Column).ComputedField = "2:=((1:=int(0:= date(%1)-date(%0))) = 0 ? '' : str(=:1) + ' day(s)') + ( 3:=round(24*(=:0-floor(=:0))) ? (len(=:2) ? ' and ' : " +
"'') + =:3 + ' hour(s)' : '' )";
exontrol.EXTREELib.Items var_Items = extree1.Items;
int h = var_Items.AddItem(Convert.ToDateTime("1/11/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.set_CellCaption(h,1,Convert.ToDateTime("1/14/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
h = var_Items.AddItem(Convert.ToDateTime("2/22/2002 12:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.set_CellCaption(h,1,Convert.ToDateTime("3/14/2002 13:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
h = var_Items.AddItem(Convert.ToDateTime("3/13/2003",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.set_CellCaption(h,1,Convert.ToDateTime("4/11/2003 11:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
|
|
408
|
Is there a function to display the number of days between two date including the number of hours
extree1.Columns.Add("Start");
extree1.Columns.Add("End");
(extree1.Columns.Add("Duration") as exontrol.EXTREELib.Column).ComputedField = "\"D \" + int(date(%1)-date(%0)) + \" H \" + round(24*(date(%1)-date(%0) - floor(date(%1)-date(%0))))";
exontrol.EXTREELib.Items var_Items = extree1.Items;
int h = var_Items.AddItem(Convert.ToDateTime("1/11/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.set_CellCaption(h,1,Convert.ToDateTime("1/14/2001 23:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
h = var_Items.AddItem(Convert.ToDateTime("2/22/2002 12:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.set_CellCaption(h,1,Convert.ToDateTime("3/14/2002 13:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
h = var_Items.AddItem(Convert.ToDateTime("3/13/2003",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.set_CellCaption(h,1,Convert.ToDateTime("4/11/2003 11:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
|
|
407
|
How can I display the number of days between two dates
extree1.Columns.Add("Start");
extree1.Columns.Add("End");
(extree1.Columns.Add("Duration") as exontrol.EXTREELib.Column).ComputedField = "(date(%1)-date(%0)) + ' days'";
exontrol.EXTREELib.Items var_Items = extree1.Items;
int h = var_Items.AddItem(Convert.ToDateTime("1/11/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.set_CellCaption(h,1,Convert.ToDateTime("1/14/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
h = var_Items.AddItem(Convert.ToDateTime("2/22/2002",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.set_CellCaption(h,1,Convert.ToDateTime("3/14/2002",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
h = var_Items.AddItem(Convert.ToDateTime("3/13/2003",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.set_CellCaption(h,1,Convert.ToDateTime("4/11/2003",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
|
|
406
|
How can I get second part of the date
extree1.Columns.Add("Date");
(extree1.Columns.Add("Second") as exontrol.EXTREELib.Column).ComputedField = "sec(date(%0))";
exontrol.EXTREELib.Items var_Items = extree1.Items;
var_Items.AddItem(Convert.ToDateTime("1/11/2001 10:10:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("2/22/2002 11:01:22",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("3/13/2003 12:23:01",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("4/14/2004 13:11:59",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
|
|
405
|
How can I get minute part of the date
extree1.Columns.Add("Date");
(extree1.Columns.Add("Minute") as exontrol.EXTREELib.Column).ComputedField = "min(date(%0))";
exontrol.EXTREELib.Items var_Items = extree1.Items;
var_Items.AddItem(Convert.ToDateTime("1/11/2001 10:10:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("2/22/2002 11:01:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("3/13/2003 12:23:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("4/14/2004 13:11:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
|
|
404
|
How can I check the hour part only so I know it was afternoon
extree1.ConditionalFormats.Add("hour(%0)>=12",null).Bold = true;
extree1.Columns.Add("Date");
(extree1.Columns.Add("Hour") as exontrol.EXTREELib.Column).ComputedField = "hour(%0)";
exontrol.EXTREELib.Items var_Items = extree1.Items;
var_Items.AddItem(Convert.ToDateTime("1/11/2001 10:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("2/22/2002 11:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("3/13/2003 12:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("4/14/2004 13:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
|
|
403
|
What about a function to get the day in the week, or days since Sunday
extree1.Columns.Add("Date");
(extree1.Columns.Add("WeekDay") as exontrol.EXTREELib.Column).ComputedField = "weekday(%0)";
exontrol.EXTREELib.Items var_Items = extree1.Items;
var_Items.AddItem(Convert.ToDateTime("1/11/2001 10:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("2/22/2002 11:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("3/13/2003 12:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("4/14/2004 13:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
|
|
402
|
Is there any function to get the day of the year or number of days since January 1st
extree1.Columns.Add("Date");
(extree1.Columns.Add("Day since January 1st") as exontrol.EXTREELib.Column).ComputedField = "yearday(%0)";
exontrol.EXTREELib.Items var_Items = extree1.Items;
var_Items.AddItem(Convert.ToDateTime("1/11/2001 10:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("2/22/2002 11:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("3/13/2003 12:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("4/14/2004 13:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
|
|
401
|
How can I display only the day of the date
extree1.Columns.Add("Date");
(extree1.Columns.Add("Day") as exontrol.EXTREELib.Column).ComputedField = "day(%0)";
exontrol.EXTREELib.Items var_Items = extree1.Items;
var_Items.AddItem(Convert.ToDateTime("1/11/2001 10:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("2/22/2002 11:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("3/13/2003 12:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("4/14/2004 13:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
|